2013-03-22 - 5910.200 - Rel Notes - Contracts - Release 007 #BIReleases2013
Release Notes:
5910.200 - Contracts - SA210
Admin Info
Purpose
|
Including Contract Information in SA210 report
|
Release No
|
007
|
Submitted
|
03-22-2013
|
Submitted by
|
Mallareddy D
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Narendra K
|
Object(s) Tested By
|
Narendra K
|
Report Name
SA210 - Sales Analysis by Region, Sales Org and Customer
BEx Query
ZMP_OPASA_Q015
NEC Crystal Reports Standards Check
1. SA210 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SA210 NEC CR checklist has been sent to NEC and also attached here for reference.
SA210 NEC CR Standard Check List.xlsx
Summary Level Check
Test Conducted
Report Header
Year 2013
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
3,080,700
|
3,080,700
|
Pass
|
2
|
Ship Rev
|
31,542,208
|
31,542,208
|
Pass
|
3
|
Open Qty
|
3,376
|
3,376
|
Pass
|
4
|
Open Rev
|
35,045
|
35,045
|
Pass
|
5
|
Cost
|
13,181,371
|
13,181,371
|
Pass
|
6
|
Comm
|
893,035
|
893,035
|
Pass
|
7
|
Royalty
|
4,541,236
|
4,541,236
|
Pass
|
8
|
Contrib
|
13,061,456
|
13,061,456
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
4,050,055
|
4,050,055
|
Pass
|
2
|
Ship Rev
|
44,579,749
|
44,579,749
|
Pass
|
3
|
Open Qty
|
795,295
|
795,295
|
Pass
|
4
|
Open Rev
|
9,214,997
|
9,214,997
|
Pass
|
5
|
Cost
|
18,753,268
|
18,753,268
|
Pass
|
6
|
Comm
|
1,181,961
|
1,181,961
|
Pass
|
7
|
Royalty
|
6,480,588
|
6,480,588
|
Pass
|
8
|
Contrib
|
18,555,696
|
18,555,696
|
Pass
|
Year 2012
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
1,819,250
|
1,819,250
|
Pass
|
2
|
Ship Rev
|
17,923,109
|
17,923,109
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
6,993,438
|
6,993,438
|
Pass
|
6
|
Comm
|
609,317
|
609,317
|
Pass
|
7
|
Royalty
|
2,271,941
|
2,271,941
|
Pass
|
8
|
Contrib
|
8,048,412
|
8,048,412
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
5,207,443
|
5,207,443
|
Pass
|
2
|
Ship Rev
|
61,590,962
|
61,590,962
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
20,086,092
|
20,086,092
|
Pass
|
6
|
Comm
|
1,769,692
|
1,769,692
|
Pass
|
7
|
Royalty
|
9,280,874
|
9,280,874
|
Pass
|
8
|
Contrib
|
30,454,304
|
30,454,304
|
Pass
|
Second Level Check
Grouping: Region > Sales Org > Customer
Test Conducted
Group: Emerging Markets
Year 2013
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
112,564
|
112,564
|
Pass
|
2
|
Ship Rev
|
1,616,463
|
1,616,463
|
Pass
|
3
|
Open Qty
|
425
|
425
|
Pass
|
4
|
Open Rev
|
5,523
|
5,523
|
Pass
|
5
|
Cost
|
488,797
|
488,797
|
Pass
|
6
|
Comm
|
9,998
|
9,998
|
Pass
|
7
|
Royalty
|
223,577
|
223,577
|
Pass
|
8
|
Contrib
|
894,091
|
894,091
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
103,180
|
103,180
|
Pass
|
2
|
Ship Rev
|
1,403,166
|
1,403,166
|
Pass
|
3
|
Open Qty
|
60,000
|
60,000
|
Pass
|
4
|
Open Rev
|
882,953
|
882,953
|
Pass
|
5
|
Cost
|
503,264
|
503,264
|
Pass
|
6
|
Comm
|
8,287
|
8,287
|
Pass
|
7
|
Royalty
|
202,159
|
202,159
|
Pass
|
8
|
Contrib
|
689,456
|
689,456
|
Pass
|
Year 2012
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
59,057
|
59,057
|
Pass
|
2
|
Ship Rev
|
835,799
|
835,799
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
252,715
|
252,715
|
Pass
|
6
|
Comm
|
6,073
|
6,073
|
Pass
|
7
|
Royalty
|
133,778
|
133,778
|
Pass
|
8
|
Contrib
|
443,232
|
443,232
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
168,503
|
168,503
|
Pass
|
2
|
Ship Rev
|
2,160,878
|
2,160,878
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
689,877
|
689,877
|
Pass
|
6
|
Comm
|
10,478
|
10,478
|
Pass
|
7
|
Royalty
|
333,818
|
333,818
|
Pass
|
8
|
Contrib
|
1,126,705
|
1,126,705
|
Pass
|
Third Level Check
Test Conducted
Group: Emerging Markets > Australia Sales
Year 2013
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
13,063
|
13,063
|
Pass
|
2
|
Ship Rev
|
272,973
|
272,973
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
62,605
|
62,605
|
Pass
|
6
|
Comm
|
9,386
|
9,386
|
Pass
|
7
|
Royalty
|
37,591
|
37,591
|
Pass
|
8
|
Contrib
|
163,392
|
163,392
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
16,936
|
16,936
|
Pass
|
2
|
Ship Rev
|
275,948
|
275,948
|
Pass
|
3
|
Open Qty
|
3,354
|
3,354
|
Pass
|
4
|
Open Rev
|
65,458
|
65,458
|
Pass
|
5
|
Cost
|
78,281
|
78,281
|
Pass
|
6
|
Comm
|
8,089
|
8,089
|
Pass
|
7
|
Royalty
|
39,922
|
39,922
|
Pass
|
8
|
Contrib
|
150,655
|
150,655
|
Pass
|
Year 2012
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
11,323
|
11,323
|
Pass
|
2
|
Ship Rev
|
243,910
|
243,910
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
39,317
|
39,317
|
Pass
|
6
|
Comm
|
5,871
|
5,871
|
Pass
|
7
|
Royalty
|
37,960
|
37,960
|
Pass
|
8
|
Contrib
|
160,763
|
160,763
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
19,338
|
19,338
|
Pass
|
2
|
Ship Rev
|
348,035
|
348,035
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
63,279
|
63,279
|
Pass
|
6
|
Comm
|
10,026
|
10,026
|
Pass
|
7
|
Royalty
|
59,614
|
59,614
|
Pass
|
8
|
Contrib
|
215,117
|
215,117
|
Pass
|
Fourth Level Check
Test Conducted
Group: Emerging Markets > Australia Sales > CULTURE KINGS
Year 2013
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
6,261
|
6,261
|
Pass
|
2
|
Ship Rev
|
124,628
|
124,628
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
21,921
|
21,921
|
Pass
|
6
|
Comm
|
4,985
|
4,985
|
Pass
|
7
|
Royalty
|
15,630
|
15,630
|
Pass
|
8
|
Contrib
|
82,092
|
82,092
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
1,629
|
1,629
|
Pass
|
2
|
Ship Rev
|
19,469
|
19,469
|
Pass
|
3
|
Open Qty
|
1,220
|
1,220
|
Pass
|
4
|
Open Rev
|
25,915
|
25,915
|
Pass
|
5
|
Cost
|
5,368
|
5,368
|
Pass
|
6
|
Comm
|
779
|
779
|
Pass
|
7
|
Royalty
|
329
|
329
|
Pass
|
8
|
Contrib
|
12,994
|
12,994
|
Pass
|
Year 2012
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
3,672
|
3,672
|
Pass
|
2
|
Ship Rev
|
71,108
|
71,108
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
12,547
|
12,547
|
Pass
|
6
|
Comm
|
2,844
|
2,844
|
Pass
|
7
|
Royalty
|
11,300
|
11,300
|
Pass
|
8
|
Contrib
|
44,417
|
44,417
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
7,530
|
19,338
|
Pass
|
2
|
Ship Rev
|
166,129
|
348,035
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
20,235
|
20,235
|
Pass
|
6
|
Comm
|
6,646
|
6,646
|
Pass
|
7
|
Royalty
|
26,227
|
26,227
|
Pass
|
8
|
Contrib
|
113,021
|
113,021
|
Pass
|
Reference Document (Specification)
2013-03-15 - 5910.200 - Spec - Contract Reports